---
title: "SQL-027: Retrieve PPD scheduled degree-award table"
summary: Retrieve PPD scheduled degree-award table
status: draft
owner: SAIF Documentation Generator
last_reviewed: 2026-08-21
library: SAIF.Business.Claim
reference_type: embedded
---

# SQL-027 Retrieve PPD scheduled degree-award table

Retrieves the effective-dated scheduled degree-award amounts used by `clsPPDScheduledDegreeAwards.GetAwardAmount`.

## Classification



| Field | Value |
| --- | --- |
| **SQL ID** | SQL-027 |
| **Operation type** | Read |
| **Execution method** | Inline SQL (SqlHelper.ResultSetQuery) |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsPPDScheduledDegreeAwards` |
| **Criteria property** | `(none)` |
| **Lifecycle method** | `GetScheduledDegreeAwards` |

## Tables



| Table | Access | Columns used |
| --- | --- | --- |
| [CL_PPD_SCHED_DEGREE_AWARD](../database-tables.md#cl_ppd_sched_degree_award) | SELECT | EFFECTIVE_DATE, AWARD_PER_DEGREE_AMT |

## Sample SQL

```sql
-- Retrieve PPD scheduled degree-award table
select effective_date        Eff_dt,
       award_per_degree_amt  award
  from cl_ppd_sched_degree_award
```

## Operations and processes

- [PPD award calculation](../operations/ppd-award-calc.md)

## Sources
- SAIF.Business.Claim/clsPPDScheduledDegreeAwards.vb